/*
 * 孙建雄 2021-18
 */
package cn.edu.tyu.finance.thingstype.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import cn.edu.tyu.finance.thingstype.domain.Users;
import cn.edu.tyu.finance.util.DbUtil;

/**
 *
 * @author sunjianxiong
 * @version 1.0
 */
public class UserDaoImpl {
	private int addUsers(Users users) throws SQLException{
		//1、获取到数据库的连接
		Connection conn = DbUtil.getConnection();
		//2、编写sql语句
		String sql ="insert into users values(?,?,?)";
		//3、获取预编译语句的执行者
		PreparedStatement ps = 
				conn.prepareStatement(sql);
		//4、设置参数
		ps.setString(1,users.getUserid());
		ps.setString(2, users.getUsername());
		ps.setString(3, users.getUserpsw());
		//5、执行sql语句，返回影响的行数
		int res =ps.executeUpdate();
		//6、释放数据库的连接
		DbUtil.backConn(conn, ps, null);
		return res;
	}
	/**
	 * 
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		UserDaoImpl userDao =new UserDaoImpl();
		Users users=new Users();
		users.setUserid("1");
		users.setUsername("zs");
		users.setUserpsw("123456");
	    int res=userDao.addUsers(users);
	    System.out.println(res=+res);	
	}

}
